#+TITLE: Readme for Graph Spending

Begin here for the data
[[https://github.com/netAction/hochschulwatch/blob/gh-pages/import/daten/sponsoring.csv]] Sponsoring

The reast is in the parrent folder daten

* Cypher
#+BEGIN_SRC cypher
LOAD CSV FROM '/home/s0/Code/Projects/OSI/graphsForSpenders/dm-unis-unique.csv' AS line;
CREATE (:Uni { name: line[1] });
#+END_SRC

#+BEGIN_SRC
WITH "/home/s0/Code/Projects/OSI/graphsForSpenders/" AS base
WITH base + "dm-unis-unique.csv" AS uri
LOAD CSV WITH HEADERS FROM uri AS row
MERGE (:uni {id: row.id})
#+END_SRC

#+BEGIN_SRC cypher
WITH base + "dm-relationship-geldspende.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row
MERGE (source:Geber {id: row.src})
MERGE (destination:Uni {id: row.dst})
MERGE (source)-[:MONEY_GRANT {year: row.year, sum: row.sum, source:row.source explanation:row.expl} ]-> (destination)
#+END_SRC

#+BEGIN_SRC
WITH "https://notabug.org/ProTransparenz/spending2graphs/raw/master/" AS base
WITH base + "dm-relationship-geldleistung.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row
MERGE (source:Geber {id: row.src})
MERGE (destination:Uni {id: row.dst})
MERGE (source)-[:MONEY_GRANT {year: row.year, sum: row.syn} ]-> (destination)
#+END_SRC
https://notabug.org/ProTransparenz/spending2graphs/raw/master/dm-relationship-geldspende.csv


state;dst;year;src;rel;art;wert;note;alt;src

Bundesland	Universität	Jahr	Name des Gebers	Geld-/Sachspende	Art der Leistung	Wert	Hinweis	Alternativname	Quelle

#+BEGIN_SRC
WITH "https://notabug.org/ProTransparenz/spending2graphs/raw/master/" AS base
WITH base + "sponsoring.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row with row where row.src is not null where row.dst is not null
MERGE (source:Geber {id: row.src, state:row.state})
MERGE (destination:Uni {id: row.dst})
MERGE (source)-[:MONEY_GRANT {year: row.year, value: row.value, type:row.rel, art:row.art, alt:row.alt, source:row.source}]-> (destination)
#+END_SRC
